Q: B-tree of order n is a order-n multiway tree in which each non-root node contains __________
Solution: A non-root node in a B-tree of order n contains at least (n – 1)/2 keys. And contains a maximum of (n – 1) keys and n sons.
Q: Which of the following is the most widely used external memory data structure?
Solution: In external memory, the data is transferred in form of blocks. These blocks have data valued and pointers. And B-tree can hold both the data values and pointers. So B-tree is used as an external memory data structure.
Q: A B-tree of order 4 and of height 3 will have a maximum of _______ keys.
Solution: A B-tree of order m of height h will have the maximum number of keys when all nodes are completely filled. So, the B-tree will have n = (mh+1 – 1) keys in this situation. So, required number of maximum keys = 43+1 – 1 = 256 – 1 = 255.
Q: Five node splitting operations occurred when an entry is inserted into a B-tree. Then how many nodes are written?
Solution: If s splits occur in a B-tree, 2s + 1 nodes are written (2 halves of each split and the parent of the last node split). So, if 5 splits occurred, then 2 * 5 + 1, i.e. 11 nodes are written.
Q: B-tree and AVL tree have the same worst case time complexity for insertion and deletion.
Solution: Both the B-tree and the AVL tree have O(log n) as worst case time complexity for insertion and deletion.
Q: 2-3-4 trees are B-trees of order 4. They are an isometric of _____ trees.
Solution: 2-3-4 trees are isometric of Red-Black trees. It means that, for every 2-3-4 tree, there exists a Red-Black tree with data elements in the same order.
Q: What is the best case height of a B-tree of order n and which has k keys?
Solution: B-tree of order n and with height k has best case height h, where h = logn (k+1) – 1. The best case occurs when all the nodes are completely filled with keys.
Q: Compression techniques can be used on the keys to reduce both space and time requirements in a B-tree.
Solution: The front compression and the rear compression are techniques used to reduce space and time requirements in B-tree. The compression enables to retain more keys in a node so that the number of nodes needed can be reduced.
Q: Which of the following is true?
Solution: The average probability of the split is 1/(⌈m / 2⌉ – 1), where m is the order of B-tree. So, if m larger, the probability of split will be less.
Q: In a B+ tree, both the internal nodes and the leaves have keys.
Solution: In a B+ -tree, only the leaves have keys, and these keys are replicated in non-leaf nodes for defining the path for locating individual records.
You Have Score    | /10 |